package com.hotelvip.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hotelvip.entity.User;
import org.apache.ibatis.annotations.Select;
import java.util.List;

/**
 * 客户用户dao
 *
 * @author Lzh
 * @date 2020/12/14 14:40
 */

public interface UserMapper extends BaseMapper<User> {
    @Select("SELECT v_status, count(*)  FROM ht_user WHERE v_status = 1 OR v_status = 0 GROUP BY v_status")
    List<Integer> getTotalUsers();

    List<User> getDeleteUsers();

}
